JCapper Message Board

JCapper 101
-- Can I search for a horse by name or Dam in the sql data window.

Home	Register Log In

Can I search for a horse by name or Dam in the sql data window.

bartsharkattack
3/18/2015
10:49:06 AM

I am looking for babies of horses I bred or raced in the past. I saw one mare I bred had a filly in Indiana with four starts, just thought it would be cool to pull up her pp's but i have no idea where or when she raced.

jeff
3/18/2015
2:54:53 PM

Very easy to do.

The following sql expression is one example of how to pull up all records for a specific horse from your StarterHistory Table:

Select * from StarterHistory WHERE HORSENAME = 'SHARED BELIEF'

The following sql expression is one example of how to pull up every record for a specific sire from your StarterHistory Table:

Select * from StarterHistory WHERE SIRE = 'TAPIT'

The following sql expression is one example of how to pull up every record for a specific dam from your StarterHistory Table:

Select * from StarterHistory WHERE DAM = 'ESPECIALLY AWESOME'

Hint: To see the individual plays, select "+ Show Individual Plays" from the drop down before executing the query.

Also, just as with any sql expression, you can add constraints using any of the fields listed in the Table Schema Doc.

-jp

.

JCapper Message Board

JCapper 101 -- Can I search for a horse by name or Dam in the sql data window.

JCapper 101
-- Can I search for a horse by name or Dam in the sql data window.